CustomerOrderCharge

Entity Definition

Logical Name : CustomerOrderCharge
Physical Name : CO_CTORD_CHG

A Charge that may be included in an Order as part of it's Terms and Conditions. Prices, and Taxation rules for such charges are picked up by associating the charge with a MiscellaneousFee.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
CustomerOrderChargeTypeCode (FK)(PK) A unqiue retailer assigned identifier for the type of CustomerOrderCharge. CD_TYP_CTORD_CHG Code2 char(2) CustomerOrderChargeType(CO_TYP_CTORD_CHG)
ItemID (FK)(PK) A unique system assigned identifier for the retailer's SKU. ID_ITM IdentityUUID char(32) MiscellaneousFee(TR_FE_MSC)
CustomerOrderTermsAndConditionsCode (FK) A unique retailer assigned code denoting a set of Terms and Conditions for a Customer Order. CD_CTORD_TRMCD Code2 char(2) CustomerOrderTermsAndConditions(CO_CTORD_TRMCD)

Relationships

Parent Entity Verb Phrase Child Entity
CustomerOrderChargeType defines CustomerOrderCharge
CustomerOrderTermsAndConditions includes CustomerOrderCharge
MiscellaneousFee defines CustomerOrderCharge

Logical Views containing CustomerOrderCharge

Logical View
Logical 02315 - Retail Transaction - Customer Order
Logical 02316 - Distributed Order Management View
Logical 07600 - Customer Order - Macro View